Requirement already satisfied: sklearn in ./venv/lib/python3.10/site-packages (0.0.post1)

[notice] A new release of pip available: 22.2.2 -> 23.0
[notice] To update, run: pip install --upgrade pip
Requirement already satisfied: squarify in ./venv/lib/python3.10/site-packages (0.4.3)

[notice] A new release of pip available: 22.2.2 -> 23.0
[notice] To update, run: pip install --upgrade pip
/home/ayush/Documents/Project/ayush/customer_segm_RFM
Out[5]:
InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country
0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 12.1.10 8:26 2.55 17850.0 United Kingdom
1 536365 71053 WHITE METAL LANTERN 6 12.1.10 8:26 3.39 17850.0 United Kingdom
2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 12.1.10 8:26 2.75 17850.0 United Kingdom
3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 12.1.10 8:26 3.39 17850.0 United Kingdom
4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 12.1.10 8:26 3.39 17850.0 United Kingdom
... ... ... ... ... ... ... ... ...
541904 581587 22613 PACK OF 20 SPACEBOY NAPKINS 12 12.9.11 12:49 0.85 12680.0 France
541905 581587 22899 CHILDREN'S APRON DOLLY GIRL 6 12.9.11 12:49 2.10 12680.0 France
541906 581587 23254 CHILDRENS CUTLERY DOLLY GIRL 4 12.9.11 12:49 4.15 12680.0 France
541907 581587 23255 CHILDRENS CUTLERY CIRCUS PARADE 4 12.9.11 12:49 4.15 12680.0 France
541908 581587 22138 BAKING SET 9 PIECE RETROSPOT 3 12.9.11 12:49 4.95 12680.0 France

541909 rows × 8 columns

Out[7]:
Timestamp('2011-12-09 12:49:00')
Out[8]:
InvoiceNo              object
StockCode              object
Description            object
Quantity                int64
InvoiceDate    datetime64[ns]
UnitPrice             float64
CustomerID            float64
Country                object
dtype: object
2011-12-10 00:00:00
Out[11]:
InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country TotalSum Frequency
0 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 6 2010-12-01 08:26:00 2.55 17850.0 United Kingdom 15.30 373 days 15:34:00
1 536365 71053 WHITE METAL LANTERN 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 20.34 373 days 15:34:00
2 536365 84406B CREAM CUPID HEARTS COAT HANGER 8 2010-12-01 08:26:00 2.75 17850.0 United Kingdom 22.00 373 days 15:34:00
3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 20.34 373 days 15:34:00
4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 6 2010-12-01 08:26:00 3.39 17850.0 United Kingdom 20.34 373 days 15:34:00
... ... ... ... ... ... ... ... ... ... ...
541904 581587 22613 PACK OF 20 SPACEBOY NAPKINS 12 2011-12-09 12:49:00 0.85 12680.0 France 10.20 0 days 11:11:00
541905 581587 22899 CHILDREN'S APRON DOLLY GIRL 6 2011-12-09 12:49:00 2.10 12680.0 France 12.60 0 days 11:11:00
541906 581587 23254 CHILDRENS CUTLERY DOLLY GIRL 4 2011-12-09 12:49:00 4.15 12680.0 France 16.60 0 days 11:11:00
541907 581587 23255 CHILDRENS CUTLERY CIRCUS PARADE 4 2011-12-09 12:49:00 4.15 12680.0 France 16.60 0 days 11:11:00
541908 581587 22138 BAKING SET 9 PIECE RETROSPOT 3 2011-12-09 12:49:00 4.95 12680.0 France 14.85 0 days 11:11:00

541909 rows × 10 columns

Recency¶

Reference Date: 2011-12-10 00:00:00
Out[12]:
count mean std min 25% 50% 75% max
CustomerID 4372.0 15299.677722 1722.390705 12346.0 13812.75 15300.5 16778.25 18287.0
recency 4372.0 91.581199 100.772139 0.0 16.00 50.0 143.00 373.0
Out[13]:
CustomerID recency
0 12346.0 325.0
1 12347.0 2.0
2 12348.0 75.0
3 12349.0 18.0
4 12350.0 310.0
... ... ...
4367 18280.0 277.0
4368 18281.0 180.0
4369 18282.0 7.0
4370 18283.0 3.0
4371 18287.0 42.0

4372 rows × 2 columns

Frequency¶

Monetary Value¶

Out[17]:
CustomerID recency frequency TotalSum
0 12346.0 325.0 2 0.00
1 12347.0 2.0 7 4310.00
2 12348.0 75.0 4 1797.24
3 12349.0 18.0 1 1757.55
4 12350.0 310.0 1 334.40
... ... ... ... ...
4367 18280.0 277.0 1 180.60
4368 18281.0 180.0 1 80.82
4369 18282.0 7.0 3 176.60
4370 18283.0 3.0 16 2094.88
4371 18287.0 42.0 3 1837.28

4372 rows × 4 columns

Out[19]:
CustomerID    0
Recency       0
Frequency     0
Monetary      0
dtype: int64
Out[21]:
CustomerID Recency Frequency Monetary
0 12346.0 325.0 2 0.00
1 12347.0 2.0 7 4310.00
2 12348.0 75.0 4 1797.24
3 12349.0 18.0 1 1757.55
4 12350.0 310.0 1 334.40
... ... ... ... ...
4367 18280.0 277.0 1 180.60
4368 18281.0 180.0 1 80.82
4369 18282.0 7.0 3 176.60
4370 18283.0 3.0 16 2094.88
4371 18287.0 42.0 3 1837.28

4372 rows × 4 columns

Out[22]:
CustomerID Recency Frequency Monetary R F M
0 12346.0 325.0 2 0.00 1 2 1
1 12347.0 2.0 7 4310.00 4 4 4
2 12348.0 75.0 4 1797.24 2 3 4
3 12349.0 18.0 1 1757.55 3 1 4
4 12350.0 310.0 1 334.40 1 1 2
Out[23]:
CustomerID Recency Frequency Monetary R F M RFM_Segment_Concat
0 12346.0 325.0 2 0.00 1 2 1 1.02.01.0
1 12347.0 2.0 7 4310.00 4 4 4 4.04.04.0
2 12348.0 75.0 4 1797.24 2 3 4 2.03.04.0
3 12349.0 18.0 1 1757.55 3 1 4 3.01.04.0
4 12350.0 310.0 1 334.40 1 1 2 1.01.02.0
63
0     4
1    12
2     9
3     8
4     4
Name: RFM_Score, dtype: int64
Out[25]:
CustomerID Recency Frequency Monetary R F M RFM_Segment_Concat RFM_Score RFM_Level
0 12346.0 325.0 2 0.00 1 2 1 1.02.01.0 4 Requires Attention
1 12347.0 2.0 7 4310.00 4 4 4 4.04.04.0 12 Can't Loose Them
2 12348.0 75.0 4 1797.24 2 3 4 2.03.04.0 9 Can't Loose Them
3 12349.0 18.0 1 1757.55 3 1 4 3.01.04.0 8 Champions
4 12350.0 310.0 1 334.40 1 1 2 1.01.02.0 4 Requires Attention
5 12352.0 36.0 11 1545.41 3 4 3 3.04.03.0 10 Can't Loose Them
6 12353.0 204.0 1 89.00 1 1 1 1.01.01.0 3 Demands Activation
7 12354.0 232.0 1 1079.40 1 1 3 1.01.03.0 5 Promising
8 12355.0 214.0 1 459.40 1 1 2 1.01.02.0 4 Requires Attention
9 12356.0 22.0 3 2811.43 3 2 4 3.02.04.0 9 Can't Loose Them
10 12357.0 33.0 1 6207.67 3 1 4 3.01.04.0 8 Champions
11 12358.0 1.0 2 1168.06 4 2 3 4.02.03.0 9 Can't Loose Them
12 12359.0 7.0 6 6245.53 4 4 4 4.04.04.0 12 Can't Loose Them
13 12360.0 52.0 3 2662.06 2 2 4 2.02.04.0 8 Champions
14 12361.0 287.0 1 189.90 1 1 1 1.01.01.0 3 Demands Activation
                   Recency Frequency Monetary      
                      mean      mean     mean count
RFM_Level                                          
Can't Loose Them      24.9      10.0   4100.7  1718
Champions             59.3       3.2    957.5   409
Demands Activation   271.0       1.0    128.0   319
Loyal/Commited        76.6       2.5    684.3   451
Potential             95.8       1.9    478.5   475
Promising            131.5       1.5    338.3   516
Requires Attention   204.5       1.2    231.8   484